﻿<%@ Page Language="vb" MaintainScrollPositionOnPostback="true" AutoEventWireup="false" CodeBehind="Reports.aspx.vb" Inherits="WinterPark.Reports" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="Reports" runat="server">
    <div>
         <br />
         <asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Size="X-Large" Text="Report Page"></asp:Label>
         <br />
         <br />
         Customer Info<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" EmptyDataText="There are no data records to display." Width="248px" AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3">
             <Columns>
                 <asp:BoundField DataField="Surname" HeaderText="Surname" SortExpression="Surname" />
                 <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />
                 <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
                 <asp:BoundField DataField="EmailAddress" HeaderText="EmailAddress" SortExpression="EmailAddress" />
             </Columns>
             <FooterStyle BackColor="White" ForeColor="#000066" />
             <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
             <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
             <RowStyle ForeColor="#000066" />
             <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
             <SortedAscendingCellStyle BackColor="#F1F1F1" />
             <SortedAscendingHeaderStyle BackColor="#007DBB" />
             <SortedDescendingCellStyle BackColor="#CAC9C9" />
             <SortedDescendingHeaderStyle BackColor="#00547E" />
         </asp:GridView>
         <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CIS441WinterParkWebConnectionString1 %>" SelectCommand="SELECT DISTINCT [Surname], [FirstName], [Phone], [EmailAddress] FROM [CustomerTable] ORDER BY [Surname], [FirstName]">
         </asp:SqlDataSource>
         <br />
         <br />
         Available Lockers<asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1">
             <FooterStyle BackColor="White" ForeColor="#000066" />
             <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
             <ItemStyle ForeColor="#000066" />
             <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" Mode="NumericPages" />
             <SelectedItemStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
         </asp:DataGrid>
         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CIS441WinterParkWebConnectionString1 %>" SelectCommand="SELECT [LockerId], [Available], [Price] FROM [LockerTable] WHERE ([Available] = @Available)">
             <SelectParameters>
                 <asp:Parameter DefaultValue="Yes" Name="Available" Type="String" />
             </SelectParameters>
         </asp:SqlDataSource>
         <br />
         <br />
         <br />
         <br />

         
       
    </div>
    </form>
</body>
</html>
